if object_id('BIMonitor.SystemHealth') is not null
  drop table BIMonitor.SystemHealth
go

create table BIMonitor.SystemHealth
 (Environment              varchar(75) not null,
  ComponentName            varchar(75) not null,
  ComponentType            varchar(25) not null,
  ServerName               varchar(75) null,
  ComponentState           varchar(256) not null,
  CheckDate                datetime default getdate() not null,

  constraint uq_SystemHealth unique clustered(Environment,
    ComponentName,ServerName));